using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VICC_QUERYTB
    {
        public readonly static VICC_QUERYTB Instance = new VICC_QUERYTB();
         
         public void InsertICC_QUERYTB(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO ICC_QUERYTB(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryICC_QUERYTB(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM ICC_QUERYTB WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM ICC_QUERYTB  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "ICC_QUERYTB";
            Return = Result;
            return Return;
        }
        public void DeleteICC_QUERYTB(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM ICC_QUERYTB   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateICC_QUERYTB(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE ICC_QUERYTB SET "
                    +"MANDANT= :MANDANT,"
                    +"KRS= :KRS,"
                    +"LFD= :LFD,"
                    +"SDSA= :SDSA,"
                    +"GPSPPART= :GPSPPART,"
                    +"GPFBPART= :GPFBPART,"
                    +"GPZWPART= :GPZWPART,"
                    +"MDATE= :MDATE,"
                    +"APKMANDANT= :APKMANDANT,"
                    +"GABBELEG= :GABBELEG,"
                    +"GABBUCHDAT= :GABBUCHDAT,"
                    +"GAGMANDANT= :GAGMANDANT,"
                    +"GAGART= :GAGART,"
                    +"GAGVAR= :GAGVAR,"
                    +"GSMANDANT= :GSMANDANT,"
                    +"GSART= :GSART,"
                    +"GSVAR= :GSVAR,"
                    +"WAMANDANT= :WAMANDANT,"
                    +"WAART= :WAART,"
                    +"WAVAR= :WAVAR,"
                    +"WAFMANDANT= :WAFMANDANT,"
                    +"WAFART= :WAFART,"
                    +"WAFVAR= :WAFVAR,"
                    +"BMMANDANT= :BMMANDANT,"
                    +"BMAUFKRS= :BMAUFKRS,"
                    +"BMAUFLFD= :BMAUFLFD,"
                    +"BMAUFPOS= :BMAUFPOS,"
                    +"ARMANDANT= :ARMANDANT,"
                    +"ARAUFKRS= :ARAUFKRS,"
                    +"ARAUFLFD= :ARAUFLFD,"
                    +"ARAUFPOS= :ARAUFPOS,"
                    +"MLLOC= :MLLOC,"
                    +"TYPE= :TYPE,"
                    +"COMPANY= :COMPANY,"
                    +"USERID= :USERID,"
                    +"ABPART= :ABPART,"
                    +"ABPVAR= :ABPVAR,"
                    +"ABPFARBE= :ABPFARBE,"
                    +"ABPDESS= :ABPDESS,"
                    +"ABPCOLORIT= :ABPCOLORIT,"
                    +"ABPBESCHICH= :ABPBESCHICH,"
                    +"ABPGROE= :ABPGROE,"
                    +"C1= :C1,"
                    +"C2= :C2,"
                    +"C21= :C21,"
                    +"C22= :C22,"
                    +"C3= :C3,"
                    +"C31= :C31,"
                    +"C32= :C32,"
                    +"C20= :C20,"
                    +"C201= :C201,"
                    +"C202= :C202,"
                    +"C40= :C40,"
                    +"C100= :C100,"
                    +"DSTART= :DSTART,"
                    +"DEND= :DEND,"
                    +"APAKMANDANT= :APAKMANDANT,"
                    +"APAKANRKRS= :APAKANRKRS,"
                    +"APAKALFDNR= :APAKALFDNR,"
                    +"APAKAFOLGE= :APAKAFOLGE,"
                    +"APFMANDANT= :APFMANDANT,"
                    +"APFANRKRS= :APFANRKRS,"
                    +"APFALFDNR= :APFALFDNR,"
                    +"VKKMANDANT= :VKKMANDANT,"
                    +"VKKAUFKRS= :VKKAUFKRS,"
                    +"VKKAUFLFD= :VKKAUFLFD,"
                    +"GAMANDANT= :GAMANDANT,"
                    +"GAART= :GAART,"
                    +"GAVAR= :GAVAR,"
                    +"GAFARBE= :GAFARBE,"
                    +"GAAUFMSL= :GAAUFMSL,"
                    +"GAAUFKRS= :GAAUFKRS,"
                    +"GAAUFLFD= :GAAUFLFD,"
                    +"GAAUFPOS= :GAAUFPOS,"
                    +"GAPOS= :GAPOS,"
                    +"GASA= :GASA,"
                    +"BAMANDANT= :BAMANDANT,"
                    +"BAAUFKRS= :BAAUFKRS,"
                    +"BAAUFLFD= :BAAUFLFD,"
                    +"BAAUFPOS= :BAAUFPOS,"
                    +"BAPOS= :BAPOS,"
                    +"WDMANDANT= :WDMANDANT,"
                    +"WDAUFKRS= :WDAUFKRS,"
                    +"WDAUFLFD= :WDAUFLFD,"
                    +"WDAUFPOS= :WDAUFPOS,"
                    +"WDSA= :WDSA,"
                    +"WDUPOS= :WDUPOS,"
                    +"WDTYP= :WDTYP,"
                    +"FDMANDANT= :FDMANDANT,"
                    +"FDAUFKRS= :FDAUFKRS,"
                    +"FDAUFLFD= :FDAUFLFD,"
                    +"FDAUFPOS= :FDAUFPOS,"
                    +"MDMANDANT= :MDMANDANT,"
                    +"MDAUFKRS= :MDAUFKRS,"
                    +"MDAUFLFD= :MDAUFLFD,"
                    +"MDAUFPOS= :MDAUFPOS,"
                    +"ABKMANDANT= :ABKMANDANT,"
                    +"ABKAUFKRS= :ABKAUFKRS,"
                    +"ABKAUFLFD= :ABKAUFLFD,"
                    +"ABKKDAUFTNR= :ABKKDAUFTNR,"
                    +"ABFMANDANT= :ABFMANDANT,"
                    +"ABFAUFKRS= :ABFAUFKRS,"
                    +"ABFAUFLFD= :ABFAUFLFD,"
                    +"ABFAUFPOS= :ABFAUFPOS,"
                    +"ABFKSTKRS= :ABFKSTKRS,"
                    +"ABFKST= :ABFKST,"
                    +"ABFAGANG= :ABFAGANG,"
                    +"MKFERLKZ= :MKFERLKZ,"
                    +"ARAMANDANT= :ARAMANDANT,"
                    +"ARAAUFKRS= :ARAAUFKRS,"
                    +"ARAAUFLFD= :ARAAUFLFD,"
                    +"ARAAUFPOS= :ARAAUFPOS,"
                    +"ZUMANDANT= :ZUMANDANT,"
                    +"ZUAUFKRS= :ZUAUFKRS,"
                    +"ZUAUFLFD= :ZUAUFLFD,"
                    +"ZUAUFPOS= :ZUAUFPOS,"
                    +"VKPMANDANT= :VKPMANDANT,"
                    +"VKPAUFKRS= :VKPAUFKRS,"
                    +"VKPAUFLFD= :VKPAUFLFD,"
                    +"VKPAUFPOS= :VKPAUFPOS,"
                    +"ABPMANDANT= :ABPMANDANT,"
                    +"ABPAUFKRS= :ABPAUFKRS,"
                    +"ABPAUFLFD= :ABPAUFLFD,"
                    +"ABPAUFPOS= :ABPAUFPOS,"
                    +"TXTIMANDANT= :TXTIMANDANT,"
                    +"TXTITXTART= :TXTITXTART,"
                    +"TXTISIND= :TXTISIND,"
                    +"KDMANDANT= :KDMANDANT,"
                    +"KDKUNDNR= :KDKUNDNR,"
                    +"VKAMANDANT= :VKAMANDANT,"
                    +"VKAAUFKRS= :VKAAUFKRS,"
                    +"VKAAUFLFD= :VKAAUFLFD,"
                    +"ZABMANDANT= :ZABMANDANT,"
                    +"ZABNR= :ZABNR,"
                    +"KDSKUNDNR= :KDSKUNDNR,"
                    +"HRMANDANT= :HRMANDANT,"
                    +"HRBENID= :HRBENID,"
                    +"GLOMANDANT= :GLOMANDANT,"
                    +"GLOITEM= :GLOITEM,"
                    +"KDAKUNDNR= :KDAKUNDNR,"
                    +"VVMANDANT= :VVMANDANT,"
                    +"VVLIEFSCH= :VVLIEFSCH,"
                    +"VVTMANDANT= :VVTMANDANT,"
                    +"VVTAUFKRS= :VVTAUFKRS,"
                    +"VVTAUFLFD= :VVTAUFLFD,"
                    +"VVTAUFPOS= :VVTAUFPOS,"
                    +"ABAMANDANT= :ABAMANDANT,"
                    +"EXART= :EXART,"
                    +"ABAART= :ABAART,"
                    +"ABAVAR= :ABAVAR,"
                    +"ABAFARBE= :ABAFARBE,"
                    +"ABAGROE= :ABAGROE,"
                    +"FSSZUSCHN= :FSSZUSCHN,"
                    +"ABAAUFTYP= :ABAAUFTYP,"
                    +"ABAVKAUFKRS= :ABAVKAUFKRS,"
                    +"ABAVKAUFLFD= :ABAVKAUFLFD,"
                    +"ABAVKAUFPOS= :ABAVKAUFPOS,"
                    +"ABAAUFKRS= :ABAAUFKRS,"
                    +"ABAAUFLFD= :ABAAUFLFD,"
                    +"ABAAUFPOS= :ABAAUFPOS,"
                    +"ABAAPOS= :ABAAPOS,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("MANDANT", OracleType.NVarChar).Value = dwData["MANDANT"].ToString(); 
          or1.Parameters.Add("KRS", OracleType.NVarChar).Value = dwData["KRS"].ToString(); 
          or1.Parameters.Add("LFD", OracleType.NVarChar).Value = dwData["LFD"].ToString(); 
          or1.Parameters.Add("SDSA", OracleType.NVarChar).Value = dwData["SDSA"].ToString(); 
          or1.Parameters.Add("GPSPPART", OracleType.NVarChar).Value = dwData["GPSPPART"].ToString(); 
          or1.Parameters.Add("GPFBPART", OracleType.NVarChar).Value = dwData["GPFBPART"].ToString(); 
          or1.Parameters.Add("GPZWPART", OracleType.NVarChar).Value = dwData["GPZWPART"].ToString(); 
          or1.Parameters.Add("MDATE", OracleType.NVarChar).Value = dwData["MDATE"].ToString(); 
          or1.Parameters.Add("APKMANDANT", OracleType.NVarChar).Value = dwData["APKMANDANT"].ToString(); 
          or1.Parameters.Add("GABBELEG", OracleType.NVarChar).Value = dwData["GABBELEG"].ToString(); 
          or1.Parameters.Add("GABBUCHDAT", OracleType.NVarChar).Value = dwData["GABBUCHDAT"].ToString(); 
          or1.Parameters.Add("GAGMANDANT", OracleType.NVarChar).Value = dwData["GAGMANDANT"].ToString(); 
          or1.Parameters.Add("GAGART", OracleType.NVarChar).Value = dwData["GAGART"].ToString(); 
          or1.Parameters.Add("GAGVAR", OracleType.NVarChar).Value = dwData["GAGVAR"].ToString(); 
          or1.Parameters.Add("GSMANDANT", OracleType.NVarChar).Value = dwData["GSMANDANT"].ToString(); 
          or1.Parameters.Add("GSART", OracleType.NVarChar).Value = dwData["GSART"].ToString(); 
          or1.Parameters.Add("GSVAR", OracleType.NVarChar).Value = dwData["GSVAR"].ToString(); 
          or1.Parameters.Add("WAMANDANT", OracleType.NVarChar).Value = dwData["WAMANDANT"].ToString(); 
          or1.Parameters.Add("WAART", OracleType.NVarChar).Value = dwData["WAART"].ToString(); 
          or1.Parameters.Add("WAVAR", OracleType.NVarChar).Value = dwData["WAVAR"].ToString(); 
          or1.Parameters.Add("WAFMANDANT", OracleType.NVarChar).Value = dwData["WAFMANDANT"].ToString(); 
          or1.Parameters.Add("WAFART", OracleType.NVarChar).Value = dwData["WAFART"].ToString(); 
          or1.Parameters.Add("WAFVAR", OracleType.NVarChar).Value = dwData["WAFVAR"].ToString(); 
          or1.Parameters.Add("BMMANDANT", OracleType.NVarChar).Value = dwData["BMMANDANT"].ToString(); 
          or1.Parameters.Add("BMAUFKRS", OracleType.NVarChar).Value = dwData["BMAUFKRS"].ToString(); 
          or1.Parameters.Add("BMAUFLFD", OracleType.NVarChar).Value = dwData["BMAUFLFD"].ToString(); 
          or1.Parameters.Add("BMAUFPOS", OracleType.NVarChar).Value = dwData["BMAUFPOS"].ToString(); 
          or1.Parameters.Add("ARMANDANT", OracleType.NVarChar).Value = dwData["ARMANDANT"].ToString(); 
          or1.Parameters.Add("ARAUFKRS", OracleType.NVarChar).Value = dwData["ARAUFKRS"].ToString(); 
          or1.Parameters.Add("ARAUFLFD", OracleType.NVarChar).Value = dwData["ARAUFLFD"].ToString(); 
          or1.Parameters.Add("ARAUFPOS", OracleType.NVarChar).Value = dwData["ARAUFPOS"].ToString(); 
          or1.Parameters.Add("MLLOC", OracleType.NVarChar).Value = dwData["MLLOC"].ToString(); 
          or1.Parameters.Add("TYPE", OracleType.NVarChar).Value = dwData["TYPE"].ToString(); 
          or1.Parameters.Add("COMPANY", OracleType.NVarChar).Value = dwData["COMPANY"].ToString(); 
          or1.Parameters.Add("USERID", OracleType.NVarChar).Value = dwData["USERID"].ToString(); 
          or1.Parameters.Add("ABPART", OracleType.NVarChar).Value = dwData["ABPART"].ToString(); 
          or1.Parameters.Add("ABPVAR", OracleType.NVarChar).Value = dwData["ABPVAR"].ToString(); 
          or1.Parameters.Add("ABPFARBE", OracleType.NVarChar).Value = dwData["ABPFARBE"].ToString(); 
          or1.Parameters.Add("ABPDESS", OracleType.NVarChar).Value = dwData["ABPDESS"].ToString(); 
          or1.Parameters.Add("ABPCOLORIT", OracleType.NVarChar).Value = dwData["ABPCOLORIT"].ToString(); 
          or1.Parameters.Add("ABPBESCHICH", OracleType.NVarChar).Value = dwData["ABPBESCHICH"].ToString(); 
          or1.Parameters.Add("ABPGROE", OracleType.NVarChar).Value = dwData["ABPGROE"].ToString(); 
          or1.Parameters.Add("C1", OracleType.NVarChar).Value = dwData["C1"].ToString(); 
          or1.Parameters.Add("C2", OracleType.NVarChar).Value = dwData["C2"].ToString(); 
          or1.Parameters.Add("C21", OracleType.NVarChar).Value = dwData["C21"].ToString(); 
          or1.Parameters.Add("C22", OracleType.NVarChar).Value = dwData["C22"].ToString(); 
          or1.Parameters.Add("C3", OracleType.NVarChar).Value = dwData["C3"].ToString(); 
          or1.Parameters.Add("C31", OracleType.NVarChar).Value = dwData["C31"].ToString(); 
          or1.Parameters.Add("C32", OracleType.NVarChar).Value = dwData["C32"].ToString(); 
          or1.Parameters.Add("C20", OracleType.NVarChar).Value = dwData["C20"].ToString(); 
          or1.Parameters.Add("C201", OracleType.NVarChar).Value = dwData["C201"].ToString(); 
          or1.Parameters.Add("C202", OracleType.NVarChar).Value = dwData["C202"].ToString(); 
          or1.Parameters.Add("C40", OracleType.NVarChar).Value = dwData["C40"].ToString(); 
          or1.Parameters.Add("C100", OracleType.NVarChar).Value = dwData["C100"].ToString(); 
          or1.Parameters.Add("DSTART", OracleType.NVarChar).Value = dwData["DSTART"].ToString(); 
          or1.Parameters.Add("DEND", OracleType.NVarChar).Value = dwData["DEND"].ToString(); 
          or1.Parameters.Add("APAKMANDANT", OracleType.NVarChar).Value = dwData["APAKMANDANT"].ToString(); 
          or1.Parameters.Add("APAKANRKRS", OracleType.NVarChar).Value = dwData["APAKANRKRS"].ToString(); 
          or1.Parameters.Add("APAKALFDNR", OracleType.NVarChar).Value = dwData["APAKALFDNR"].ToString(); 
          or1.Parameters.Add("APAKAFOLGE", OracleType.NVarChar).Value = dwData["APAKAFOLGE"].ToString(); 
          or1.Parameters.Add("APFMANDANT", OracleType.NVarChar).Value = dwData["APFMANDANT"].ToString(); 
          or1.Parameters.Add("APFANRKRS", OracleType.NVarChar).Value = dwData["APFANRKRS"].ToString(); 
          or1.Parameters.Add("APFALFDNR", OracleType.NVarChar).Value = dwData["APFALFDNR"].ToString(); 
          or1.Parameters.Add("VKKMANDANT", OracleType.NVarChar).Value = dwData["VKKMANDANT"].ToString(); 
          or1.Parameters.Add("VKKAUFKRS", OracleType.NVarChar).Value = dwData["VKKAUFKRS"].ToString(); 
          or1.Parameters.Add("VKKAUFLFD", OracleType.NVarChar).Value = dwData["VKKAUFLFD"].ToString(); 
          or1.Parameters.Add("GAMANDANT", OracleType.NVarChar).Value = dwData["GAMANDANT"].ToString(); 
          or1.Parameters.Add("GAART", OracleType.NVarChar).Value = dwData["GAART"].ToString(); 
          or1.Parameters.Add("GAVAR", OracleType.NVarChar).Value = dwData["GAVAR"].ToString(); 
          or1.Parameters.Add("GAFARBE", OracleType.NVarChar).Value = dwData["GAFARBE"].ToString(); 
          or1.Parameters.Add("GAAUFMSL", OracleType.NVarChar).Value = dwData["GAAUFMSL"].ToString(); 
          or1.Parameters.Add("GAAUFKRS", OracleType.NVarChar).Value = dwData["GAAUFKRS"].ToString(); 
          or1.Parameters.Add("GAAUFLFD", OracleType.NVarChar).Value = dwData["GAAUFLFD"].ToString(); 
          or1.Parameters.Add("GAAUFPOS", OracleType.NVarChar).Value = dwData["GAAUFPOS"].ToString(); 
          or1.Parameters.Add("GAPOS", OracleType.NVarChar).Value = dwData["GAPOS"].ToString(); 
          or1.Parameters.Add("GASA", OracleType.NVarChar).Value = dwData["GASA"].ToString(); 
          or1.Parameters.Add("BAMANDANT", OracleType.NVarChar).Value = dwData["BAMANDANT"].ToString(); 
          or1.Parameters.Add("BAAUFKRS", OracleType.NVarChar).Value = dwData["BAAUFKRS"].ToString(); 
          or1.Parameters.Add("BAAUFLFD", OracleType.NVarChar).Value = dwData["BAAUFLFD"].ToString(); 
          or1.Parameters.Add("BAAUFPOS", OracleType.NVarChar).Value = dwData["BAAUFPOS"].ToString(); 
          or1.Parameters.Add("BAPOS", OracleType.NVarChar).Value = dwData["BAPOS"].ToString(); 
          or1.Parameters.Add("WDMANDANT", OracleType.NVarChar).Value = dwData["WDMANDANT"].ToString(); 
          or1.Parameters.Add("WDAUFKRS", OracleType.NVarChar).Value = dwData["WDAUFKRS"].ToString(); 
          or1.Parameters.Add("WDAUFLFD", OracleType.NVarChar).Value = dwData["WDAUFLFD"].ToString(); 
          or1.Parameters.Add("WDAUFPOS", OracleType.NVarChar).Value = dwData["WDAUFPOS"].ToString(); 
          or1.Parameters.Add("WDSA", OracleType.NVarChar).Value = dwData["WDSA"].ToString(); 
          or1.Parameters.Add("WDUPOS", OracleType.NVarChar).Value = dwData["WDUPOS"].ToString(); 
          or1.Parameters.Add("WDTYP", OracleType.NVarChar).Value = dwData["WDTYP"].ToString(); 
          or1.Parameters.Add("FDMANDANT", OracleType.NVarChar).Value = dwData["FDMANDANT"].ToString(); 
          or1.Parameters.Add("FDAUFKRS", OracleType.NVarChar).Value = dwData["FDAUFKRS"].ToString(); 
          or1.Parameters.Add("FDAUFLFD", OracleType.NVarChar).Value = dwData["FDAUFLFD"].ToString(); 
          or1.Parameters.Add("FDAUFPOS", OracleType.NVarChar).Value = dwData["FDAUFPOS"].ToString(); 
          or1.Parameters.Add("MDMANDANT", OracleType.NVarChar).Value = dwData["MDMANDANT"].ToString(); 
          or1.Parameters.Add("MDAUFKRS", OracleType.NVarChar).Value = dwData["MDAUFKRS"].ToString(); 
          or1.Parameters.Add("MDAUFLFD", OracleType.NVarChar).Value = dwData["MDAUFLFD"].ToString(); 
          or1.Parameters.Add("MDAUFPOS", OracleType.NVarChar).Value = dwData["MDAUFPOS"].ToString(); 
          or1.Parameters.Add("ABKMANDANT", OracleType.NVarChar).Value = dwData["ABKMANDANT"].ToString(); 
          or1.Parameters.Add("ABKAUFKRS", OracleType.NVarChar).Value = dwData["ABKAUFKRS"].ToString(); 
          or1.Parameters.Add("ABKAUFLFD", OracleType.NVarChar).Value = dwData["ABKAUFLFD"].ToString(); 
          or1.Parameters.Add("ABKKDAUFTNR", OracleType.NVarChar).Value = dwData["ABKKDAUFTNR"].ToString(); 
          or1.Parameters.Add("ABFMANDANT", OracleType.NVarChar).Value = dwData["ABFMANDANT"].ToString(); 
          or1.Parameters.Add("ABFAUFKRS", OracleType.NVarChar).Value = dwData["ABFAUFKRS"].ToString(); 
          or1.Parameters.Add("ABFAUFLFD", OracleType.NVarChar).Value = dwData["ABFAUFLFD"].ToString(); 
          or1.Parameters.Add("ABFAUFPOS", OracleType.NVarChar).Value = dwData["ABFAUFPOS"].ToString(); 
          or1.Parameters.Add("ABFKSTKRS", OracleType.NVarChar).Value = dwData["ABFKSTKRS"].ToString(); 
          or1.Parameters.Add("ABFKST", OracleType.NVarChar).Value = dwData["ABFKST"].ToString(); 
          or1.Parameters.Add("ABFAGANG", OracleType.NVarChar).Value = dwData["ABFAGANG"].ToString(); 
          or1.Parameters.Add("MKFERLKZ", OracleType.NVarChar).Value = dwData["MKFERLKZ"].ToString(); 
          or1.Parameters.Add("ARAMANDANT", OracleType.NVarChar).Value = dwData["ARAMANDANT"].ToString(); 
          or1.Parameters.Add("ARAAUFKRS", OracleType.NVarChar).Value = dwData["ARAAUFKRS"].ToString(); 
          or1.Parameters.Add("ARAAUFLFD", OracleType.NVarChar).Value = dwData["ARAAUFLFD"].ToString(); 
          or1.Parameters.Add("ARAAUFPOS", OracleType.NVarChar).Value = dwData["ARAAUFPOS"].ToString(); 
          or1.Parameters.Add("ZUMANDANT", OracleType.NVarChar).Value = dwData["ZUMANDANT"].ToString(); 
          or1.Parameters.Add("ZUAUFKRS", OracleType.NVarChar).Value = dwData["ZUAUFKRS"].ToString(); 
          or1.Parameters.Add("ZUAUFLFD", OracleType.NVarChar).Value = dwData["ZUAUFLFD"].ToString(); 
          or1.Parameters.Add("ZUAUFPOS", OracleType.NVarChar).Value = dwData["ZUAUFPOS"].ToString(); 
          or1.Parameters.Add("VKPMANDANT", OracleType.NVarChar).Value = dwData["VKPMANDANT"].ToString(); 
          or1.Parameters.Add("VKPAUFKRS", OracleType.NVarChar).Value = dwData["VKPAUFKRS"].ToString(); 
          or1.Parameters.Add("VKPAUFLFD", OracleType.NVarChar).Value = dwData["VKPAUFLFD"].ToString(); 
          or1.Parameters.Add("VKPAUFPOS", OracleType.NVarChar).Value = dwData["VKPAUFPOS"].ToString(); 
          or1.Parameters.Add("ABPMANDANT", OracleType.NVarChar).Value = dwData["ABPMANDANT"].ToString(); 
          or1.Parameters.Add("ABPAUFKRS", OracleType.NVarChar).Value = dwData["ABPAUFKRS"].ToString(); 
          or1.Parameters.Add("ABPAUFLFD", OracleType.NVarChar).Value = dwData["ABPAUFLFD"].ToString(); 
          or1.Parameters.Add("ABPAUFPOS", OracleType.NVarChar).Value = dwData["ABPAUFPOS"].ToString(); 
          or1.Parameters.Add("TXTIMANDANT", OracleType.NVarChar).Value = dwData["TXTIMANDANT"].ToString(); 
          or1.Parameters.Add("TXTITXTART", OracleType.NVarChar).Value = dwData["TXTITXTART"].ToString(); 
          or1.Parameters.Add("TXTISIND", OracleType.NVarChar).Value = dwData["TXTISIND"].ToString(); 
          or1.Parameters.Add("KDMANDANT", OracleType.NVarChar).Value = dwData["KDMANDANT"].ToString(); 
          or1.Parameters.Add("KDKUNDNR", OracleType.NVarChar).Value = dwData["KDKUNDNR"].ToString(); 
          or1.Parameters.Add("VKAMANDANT", OracleType.NVarChar).Value = dwData["VKAMANDANT"].ToString(); 
          or1.Parameters.Add("VKAAUFKRS", OracleType.NVarChar).Value = dwData["VKAAUFKRS"].ToString(); 
          or1.Parameters.Add("VKAAUFLFD", OracleType.NVarChar).Value = dwData["VKAAUFLFD"].ToString(); 
          or1.Parameters.Add("ZABMANDANT", OracleType.NVarChar).Value = dwData["ZABMANDANT"].ToString(); 
          or1.Parameters.Add("ZABNR", OracleType.NVarChar).Value = dwData["ZABNR"].ToString(); 
          or1.Parameters.Add("KDSKUNDNR", OracleType.NVarChar).Value = dwData["KDSKUNDNR"].ToString(); 
          or1.Parameters.Add("HRMANDANT", OracleType.NVarChar).Value = dwData["HRMANDANT"].ToString(); 
          or1.Parameters.Add("HRBENID", OracleType.NVarChar).Value = dwData["HRBENID"].ToString(); 
          or1.Parameters.Add("GLOMANDANT", OracleType.NVarChar).Value = dwData["GLOMANDANT"].ToString(); 
          or1.Parameters.Add("GLOITEM", OracleType.NVarChar).Value = dwData["GLOITEM"].ToString(); 
          or1.Parameters.Add("KDAKUNDNR", OracleType.NVarChar).Value = dwData["KDAKUNDNR"].ToString(); 
          or1.Parameters.Add("VVMANDANT", OracleType.NVarChar).Value = dwData["VVMANDANT"].ToString(); 
          or1.Parameters.Add("VVLIEFSCH", OracleType.NVarChar).Value = dwData["VVLIEFSCH"].ToString(); 
          or1.Parameters.Add("VVTMANDANT", OracleType.NVarChar).Value = dwData["VVTMANDANT"].ToString(); 
          or1.Parameters.Add("VVTAUFKRS", OracleType.NVarChar).Value = dwData["VVTAUFKRS"].ToString(); 
          or1.Parameters.Add("VVTAUFLFD", OracleType.NVarChar).Value = dwData["VVTAUFLFD"].ToString(); 
          or1.Parameters.Add("VVTAUFPOS", OracleType.NVarChar).Value = dwData["VVTAUFPOS"].ToString(); 
          or1.Parameters.Add("ABAMANDANT", OracleType.NVarChar).Value = dwData["ABAMANDANT"].ToString(); 
          or1.Parameters.Add("EXART", OracleType.NVarChar).Value = dwData["EXART"].ToString(); 
          or1.Parameters.Add("ABAART", OracleType.NVarChar).Value = dwData["ABAART"].ToString(); 
          or1.Parameters.Add("ABAVAR", OracleType.NVarChar).Value = dwData["ABAVAR"].ToString(); 
          or1.Parameters.Add("ABAFARBE", OracleType.NVarChar).Value = dwData["ABAFARBE"].ToString(); 
          or1.Parameters.Add("ABAGROE", OracleType.NVarChar).Value = dwData["ABAGROE"].ToString(); 
          or1.Parameters.Add("FSSZUSCHN", OracleType.NVarChar).Value = dwData["FSSZUSCHN"].ToString(); 
          or1.Parameters.Add("ABAAUFTYP", OracleType.NVarChar).Value = dwData["ABAAUFTYP"].ToString(); 
          or1.Parameters.Add("ABAVKAUFKRS", OracleType.NVarChar).Value = dwData["ABAVKAUFKRS"].ToString(); 
          or1.Parameters.Add("ABAVKAUFLFD", OracleType.NVarChar).Value = dwData["ABAVKAUFLFD"].ToString(); 
          or1.Parameters.Add("ABAVKAUFPOS", OracleType.NVarChar).Value = dwData["ABAVKAUFPOS"].ToString(); 
          or1.Parameters.Add("ABAAUFKRS", OracleType.NVarChar).Value = dwData["ABAAUFKRS"].ToString(); 
          or1.Parameters.Add("ABAAUFLFD", OracleType.NVarChar).Value = dwData["ABAAUFLFD"].ToString(); 
          or1.Parameters.Add("ABAAUFPOS", OracleType.NVarChar).Value = dwData["ABAAUFPOS"].ToString(); 
          or1.Parameters.Add("ABAAPOS", OracleType.NVarChar).Value = dwData["ABAAPOS"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
